package com.gudaomai.ekproject.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.gudaomai.ekproject.common.EkBaseMapper;
import com.gudaomai.ekproject.entity.ProjectSysuser;

/**
 * <p>
 * project_sysuser Mapper 接口
 * </p>
 *
 * @author zenghualu
 * @since 2017-06-26
 */
public interface ProjectSysuserMapper extends EkBaseMapper<ProjectSysuser> {

	@Delete("delete from project_sysuser where project_id=#{pid} and sysuser_id=#{uid}")
	public int delProjectUserByPidUid(@Param("pid") String pid, @Param("uid") String uid);

	@Select("select * from project_sysuser where project_id=#{pid} and sysuser_id=#{uid}")
	public ProjectSysuser getProjectUserByPidUid(@Param("pid") String pid, @Param("uid") String uid);

	@Select("select * from project_sysuser where sysuser_id=#{uid}")
	public List<ProjectSysuser> getProjectUserByUid(@Param("uid") String uid);

}